from sqlalchemy import Table, MetaData, Column, Integer, String, ForeignKey,Date
from sqlalchemy.orm import registry
mapper_registry = registry()
Base = mapper_registry.generate_base()

# 教育经历
class Education_logs(Base):
    __tablename__ = "education_logs"
    e_id = Column(String(32), primary_key=True)
    st_id = Column(String(32))
    e_name = Column(String(20))
    startTime = Column(Date)
    endTime = Column(Date)
    def __init__(self,e_id=None,st_id=None,e_name=None,startTime=None,endTime=None):
        self.e_id = e_id
        self.st_id = st_id
        self.e_name = e_name
        self.startTime = startTime
        self.endTime = endTime


    def format_str(self):
        return self.e_id+","+self.st_id+","+self.e_name+","+self.startTime+","+self.endTime






